﻿use [clz]
-- =============================================
-- Author:		luohr
-- Description:	  添加表 SalesType
-- =============================================
if exists (select 1
            from  sysobjects
           where  id = object_id('SalesType')
            and   type = 'U')
DROP TABLE [dbo].[SalesType]


/*==============================================================*/
/* Table: SalesType                                         */
/*==============================================================*/
create table SalesType (
   SalesTypeID      int                  identity,
   SalesTypeName    nvarchar(50)         not null,
   Description      ntext				 null,
   constraint PK_SalesType primary key (SalesTypeID)
)

SET IDENTITY_INSERT [dbo].SalesType ON
INSERT [dbo].[SalesType] ([SalesTypeID], [SalesTypeName], [Description]) VALUES (1, N'菜市场',N'')
INSERT [dbo].[SalesType] ([SalesTypeID], [SalesTypeName], [Description]) VALUES (2, N'其他商品',N'')
SET IDENTITY_INSERT [dbo].SalesType OFF